
DROP TABLE [dbo].[system_cron_config_data]
GO
CREATE TABLE [dbo].[system_cron_config_data] (
[JobId] int NOT NULL ,
[GroupId] nvarchar(11) NOT NULL ,
[JobKey] nvarchar(255) NOT NULL ,
[JobName] nvarchar(255) NOT NULL ,
[Assembly] nvarchar(255) NOT NULL ,
[JobType] int NOT NULL ,
[TimeSpan] int NOT NULL ,
[CronExpression] nvarchar(255) NOT NULL ,
[IsRunning] bit NULL ,
[RunTime] datetime2(7) NOT NULL ,
[NextTime] datetime2(7) NOT NULL ,
[EndTime] datetime2(7) NOT NULL ,
[TimeConsuming] int NOT NULL ,
[IsValidity] bit NULL ,
[AddTime] datetime2(7) NOT NULL ,
[Adder] nvarchar(255) NOT NULL ,
[ModifyTime] datetime2(7) NOT NULL ,
[Modifer] nvarchar(255) NOT NULL ,
[ResultMsg] nvarchar(2000) NOT NULL ,
[Immediately] bit NULL 
)


GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'JobId')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'任务ID'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'JobId'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'任务ID'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'JobId'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'GroupId')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'任务分组Id'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'GroupId'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'任务分组Id'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'GroupId'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'JobKey')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'任务键值'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'JobKey'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'任务键值'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'JobKey'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'JobName')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'任务名称'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'JobName'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'任务名称'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'JobName'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'Assembly')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'程序集'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'Assembly'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'程序集'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'Assembly'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'JobType')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'任务类型'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'JobType'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'任务类型'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'JobType'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'TimeSpan')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'任务间隔的时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'TimeSpan'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'任务间隔的时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'TimeSpan'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'CronExpression')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'CronTrigger表达式'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'CronExpression'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'CronTrigger表达式'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'CronExpression'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'IsRunning')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'是否正在运行'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'IsRunning'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'是否正在运行'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'IsRunning'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'RunTime')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'执行时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'RunTime'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'执行时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'RunTime'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'NextTime')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'下一次执行时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'NextTime'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'下一次执行时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'NextTime'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'EndTime')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'结束时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'EndTime'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'结束时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'EndTime'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'TimeConsuming')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'运行耗时(单位：毫米)'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'TimeConsuming'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'运行耗时(单位：毫米)'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'TimeConsuming'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'IsValidity')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'是否有效'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'IsValidity'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'是否有效'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'IsValidity'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'AddTime')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'新增时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'AddTime'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'新增时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'AddTime'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'Adder')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'新增人员'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'Adder'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'新增人员'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'Adder'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'ModifyTime')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'修改时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'ModifyTime'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'修改时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'ModifyTime'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'Modifer')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'修改人员'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'Modifer'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'修改人员'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'Modifer'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'ResultMsg')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'执行结果'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'ResultMsg'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'执行结果'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'ResultMsg'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'systemcronconfigdata', 
'COLUMN', N'Immediately')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'立即执行'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'Immediately'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'立即执行'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'systemcronconfigdata'
, @level2type = 'COLUMN', @level2name = N'Immediately'
GO

-- ----------------------------
-- Indexes structure for table systemcronconfigdata
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table systemcronconfigdata
-- ----------------------------
ALTER TABLE [dbo].[systemcronconfigdata] ADD PRIMARY KEY ([JobId])
GO
